Query: Select missing Language records

Preview in new tab(opens in a new tab) Use this queries to display invalid records (SQL Query): Select [Licence].[DeMaSy].[DBList].[DBId], count(*) from [Licence].[DeMaSy].[DBList] left join [DeMaSy].[DeMaSy].[Language] on [Licence].[DeMaSy].[DBList].[DBId] = [DeMaSy].[DeMaSy].[Language].[DBId] Group by [Licence].[DeMaSy].[DBList].[DBId] having count(*) < 6